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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies