changing 9k to 9,000 and 1m to 1,000,000
-
FrecklePaw
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
changing 9k to 9,000 and 1m to 1,000,000
Hi everyone, is there any way to automatically change a cell that's written as 9k to 9,000 and 1m to 1,000,000 for example?
-
HansV
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
FrecklePaw
- 2StarLounger
- Posts: 130
- Joined: 12 Aug 2020, 08:40
Re: changing 9k to 9,000 and 1m to 1,000,000
Excellent - ! I wondered if anyone would see it so started a new thread just to be sure. Thank you!
-
HansV
- Administrator
- Posts: 78446
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: changing 9k to 9,000 and 1m to 1,000,000
We can always see when a reply has been posted in an existing thread - its thread icon changes colour.
Best wishes,
Hans
Hans