Excel Rejects a my Custom Number Format

%3CLINGO-SUB%20id%3D%22lingo-sub-1814605%22%20slang%3D%22en-US%22%3EExcel%20Rejects%20a%20my%20Custom%20Number%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814605%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Day.%20This%20may%20be%20a%20simple%20error%20on%20my%20part%2C%20but%20I%20am%20not%20an%20expert%20so%20I%20seek%20help.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20custom%20formatted%20a%20number%20on%20a%20worksheet%20to%20look%20like%20this%3A%201%2C100%20Sq.m.%20using%20the%20custom%20number%20format%20(%23%2C%23%23%23%20%22Sq.m%22)%20.%20After%20saving%20and%20re-opening%20it%2C%20I%20opted%20to%20repair%20the%20file%20but%20the%20formatting%20is%20gone.%20Is%20this%20a%20setting%20problem%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHo%20do%20I%20fix%20this%3F%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1814605%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1814698%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Rejects%20a%20my%20Custom%20Number%20Format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1814698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F844318%22%20target%3D%22_blank%22%3E%40John1987%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20the%20attached%20Workbook%20on%20the%20Sheet%201.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Rajesh-S_0-1603530108223.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F229025i225B037C2324BBCC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Rajesh-S_0-1603530108223.png%22%20alt%3D%22Rajesh-S_0-1603530108223.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20applied%20the%20Custom%20Number%20Format%26nbsp%3B%20%23%2C%23%23%230%20%22Sq.Mt%22%2C%26nbsp%3B%20%26nbsp%3Band%20its%20working.%20Even%20I've%20saved%20%26amp%3B%20closed%20the%20file%20also%20quit%20from%20Excel%20and%20reopen%20the%20WB%2C%20found%20as%20it%20was.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EN.B.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EI've%20applied%20these%20also%20%23%2C%23%23%23%20%22Sq.m%22%26nbsp%3B%20%26nbsp%3Band%20(%23%2C%23%23%23%20%22Sq.m%22)%2C%20check%20column%20D%2C%20F%20%26amp%3B%20H.%3C%2FLI%3E%3CLI%3EI've%20used%20this%20on%20Excel%202013%20%26amp%3B%202016.%3C%2FLI%3E%3C%2FUL%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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 (#,### "Sq.m") . After saving and re-opening it, I opted to repair the file but the formatting is gone. Is this a setting problem?

 

Ho do I fix this? Thanks in advance.

3 Replies
Highlighted

@John1987 

 

Check the attached Workbook on the Sheet 1. 

 

Rajesh-S_0-1603530108223.png

 

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.
Highlighted

@John1987 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.

 

* Knowing the operating system would also be an advantage.

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)

Highlighted

@John1987 

 

However, here is some information on Excel for web via user-defined number format.

 

Excel provides many options for displaying numbers in different formats like percentages, currency, and dates. If the built-in formats don’t work for your needs, you might want to create a custom number format.

You can’t create custom formats in Excel for the web but if you have the Excel desktop application, you can click the Open in Excel button to open the workbook and create them. For more information, see Create a custom number format.

 

Create a custom number format

https://support.microsoft.com/en-us/office/create-a-custom-number-format-78f2a361-936b-4c03-8772-09f...

 

Thank you for your understanding and patience

 

 

Nikolino

I know I don't know anything (Socrates)