Forum Discussion

John1987's avatar
John1987
Copper Contributor
Oct 24, 2020

Excel Rejects a my Custom Number Format

Good Day. This may be a simple error on my part, but I am not an expert so I seek help.  I have custom formatted a number on a worksheet to look like this: 1,100 Sq.m. using the custom number format...
Excel for web
Rajesh_Sinha's avatar
Rajesh_Sinha
Iron Contributor
Oct 24, 2020

John1987 

 

Check the attached Workbook on the Sheet 1. 

 

 

I've applied the Custom Number Format  #,###0 "Sq.Mt",   and its working. Even I've saved & closed the file also quit from Excel and reopen the WB, found as it was.

 

N.B.

  • I've applied these also #,### "Sq.m"   and (#,### "Sq.m"), check column D, F & H.
  • I've used this on Excel 2013 & 2016.

Resources