Home

Excel Format help

Nadine75
Occasional Visitor

Hi there,

Would anyone know how I can format a column of an excel spreadsheet to change numbers that are exported into the spreadsheet in the format e.g. I107492 - but i would prefer them to be in the format 10749-2 - can I somehow custom format the cells to all change to the new format?

Thanks.

1 Reply

Hi,

 

If that's the number like 107492 you may apply custom number format (Ctrl+1) as #-#

If that's the text "107492" or "I107492" or any other one when use formulas to convert the text.

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies